﻿CREATE TABLE [CAT].[Catalogs]
(
	[Id] INT NOT NULL PRIMARY KEY IDENTITY, 
    [Name] VARCHAR(50) NOT NULL, 
    [GetDataProcedure] VARCHAR(100) NOT NULL DEFAULT '', 
	[InsertProcedure] VARCHAR(100) NOT NULL DEFAULT '', 
	[UpdateProcedure] VARCHAR(100) NOT NULL DEFAULT '', 
	[DeleteProcedure] VARCHAR(100) NOT NULL DEFAULT '', 
    [Active] INT NOT NULL DEFAULT 1, 
)

GO

CREATE INDEX [IX_CAT.Catalogs_Name] ON [CAT].[Catalogs] ([Name])